set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procOrderProduct_get_ByUserID](
@ID as int
)
AS
BEGIN 
SELECT     OrderProduct.ID, OrderProduct.OrderProducts, OrderProduct.ProductID, OrderProduct.Quantity, OrderProduct.Price, [Order].Ship_Name, [Order].Ship_Phone, 
                      Products.NameVN
FROM         OrderProduct INNER JOIN
                      Products ON OrderProduct.ProductID = Products.ID INNER JOIN
                      [Order] ON OrderProduct.ID = [Order].OrderProducts
WHERE     ([Order].UserID = @ID)
END


